The Irish comedian, 69, was in the role of Agnes Brown when he made the offensive remark which 'backfired' and 'caused offence'.